<center>
<?php include "scripts/connectDB.php";

$result = mysql_query("SELECT * FROM wepons,users,map,rank WHERE users.wep_id = wepons.wep_id AND users.map_id = map.map_id AND users.rank_id = rank.rank_id ORDER BY users.rank_id ASC");



while($row = mysql_fetch_array($result))
  {
  echo "<table class='contenttable' cellpadding='0' cellspacing='0'>";
  
  echo "<tr>";
  
  echo "<td class='tdcontenttop'>";
  echo "<center>" . "<span class='middels'>" . $row['username'] . " : " . $row['rank'] . "</span>" . "</center>";
  echo "</td>";
  
  echo "</tr>";
  echo "<tr>";
  
  echo "<td class='tdcontentmiddle'>";
  
  echo "<div id='membertable'>";
  echo "<table class='tableswithin' cellpadding='0' cellspacing='3'>";
  
  echo "<tr>";
  echo "<td width='100px'>Date of Birth:" . "</td>" . "<td>" . $row['birth'] . "</td>";
  echo "</tr>";
  
  echo "<tr>";
  echo "<td> Residence in:" . "</td>" . "<td>" . $row['country'] . "</td>";
  echo "</tr>";
  
  echo "<tr>";
  echo "<td> Fearn Since:" . "</td>" . "<td>" . $row['fearnsince'] . "</td>";
  echo "</tr>";
  
  echo "<tr>";
  echo "<td>Fav Map:" . "</td>" . "<td>" . $row['map'] . "</td>";
  echo "</tr>";
  
  echo "<tr>";
  echo "<td>Fav Wep:" . "</td>" . "<td>" . $row['weapon'] . "</td>";
  echo "</tr>";
  
  echo "<tr>";
  echo "<td> Previous Clans:" . "</td>" . "<td>" . $row['previousclans'] . "</td>";
  echo "</tr>";
  
  echo "<tr>";
  echo "<td>Quote:" . "</td>" . "<td>" . $row['quote'] . "</td>";
  echo "</tr>";
  echo "</table>";
  
  echo "</div>";
  
  echo "<div class='image-holder'>" . "<img src='" . $row['photo'] . "'/>" . "</div>";
 
  echo "<tr>";
  echo "<td class='tdcontentbottom'>" . "</td>";
  echo "</tr>";
  echo "</table>";
  
  }


mysql_close($con);
?>

</center>